<!--#include file="lib/utf-8.asp"-->
<!--#include file="lib/conn.asp"-->
<!--#include file="lib/json_lastest.asp"-->
<!--#include file="lib/json_util_lastest.asp"-->
<!--#include file="lib/saferequest.asp"-->

<%
Response.ContentType = "application/json"
sql="select port_id,port_name,country_name from port inner join country on port.port_country=country.country_id  order by country_name asc,port_name asc"
QueryToJSON(conn,sql).Flush
conn.close
set conn=nothing
%>
